Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL Tutorial
1) Aggregate Functions
2) Cast Functions Operators
3) Comparison Functions Operators
4) Control Flow Functions
5) Cursor
6) Data Dictionary
7) Data Types
8) Database
9) Date Time Functions
10) Encryption Compression Functions
11) Information Functions
12) Insert Update Delete
13) Introduction
14) Logic Operator
15) Math Numeric Functions
16) Miscellaneous Functions
17) MySQL Utilities
18) Privilege
19) Procedure Function
20) Regular Expressions
21) Select Query
22) String Functions
23) Subquery
24) Table
25) Table Join
26) Trigger
27) View

Privilege
1) A user doesnt need a password if connecting from a certain machine
2) Add a user
3) Add localhost to mysql table for accessing sample_db
4) Add your database and users to the mysql database
5) Column privilege
6) Designate an IP or host address from which the user can connect
7) FLUSHing the Privileges
8) Give a non-local user permissions on the database for use with remote clients
9) Give ALL PRIVILEGES on a database to a local user who has to use a password to access the database
10) GRANT ALL
11) GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50
12) Grant Select and Update privilege to a user
13) GRANT SELECT, UPDATE ON databaseName
14) Grant select, update privilege for a remote user
15) Granting Privileges on the new database
16) In the default setting of MySQL access privileges, every user is permitted to create databases on a local computer that begin wi
17) No other database can allow any user to connect from any host
18) Removing Permissions from a Database
19) Removing Permissions from a User
20) Revoking privileges
21) Select convert(SUBSTR(USER(),1,INSTR(USER(),@)-1) using latin1)
22) SELECT host, user, select_priv, update_priv FROM user
23) Tables_priv
24) To allow a user to connect from anywhere you would use a wildcard %
25) To remove UPDATE, INSERT and DELETE privileges
26) To restrict the user to manipulating data (rather than table or database structures)
27) WITH GRANT OPTION condition allows the user to give others privileges to that database